package lab03.test11;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.sql.Statement;

public class Test {
        public static void main(String[] args) {

//加载驱动

            Connection connection=null;

            Statement statement=null;

//表名字：t_users

            String sql="insert into t_users(id,username,password,register_datetime) values(1,'admin','admin',192312312123)";

            String sql1="insert into t_users(id,username,password,register_datetime) VALUES (2,'chen','123456',123123213123)" ;

            try {

                Class.forName("com.mysql.jdbc.Driver");

                connection= DriverManager.getConnection(

                        "jdbc:mysql://localhost:3306/java_2017?serverTimezone=UTC",

                        "root",

                        "123456"

                );

                statement=connection.createStatement();

                statement.execute(sql);

                statement.execute(sql1);

            } catch (ClassNotFoundException e) {

                e.printStackTrace();

            } catch (SQLException e) {

                e.printStackTrace();

            } finally {

                try {

                    statement.close();

                    connection.close();

                } catch (SQLException e) {

                    e.printStackTrace();

                }

            }

        }


    }
